package com.loveyukari.dao.impl;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.loveyukari.dao.BlackIpDao;

/**
*
*yangshaohua
*2017年1月23日下午7:54:39
**/
@Repository
public class JdbcBlackIpDao extends BaseDao implements BlackIpDao{

	public void insertBlackIp(String ip) {
		String sql = "insert into black_ip (ip) values(?)";
		this.getJdbcTemplate().update(sql,ip);
		
	}

	public List<String> selectBlackIpAll() {
		String sql = "select ip from black_ip";
		List<String> list = this.getJdbcTemplate().queryForList(sql,String.class);
		return list;
	}
	


	

}
